Carson Penticuff
Carson Penticuff
Reactions
-
Re: Formula and Function : COUNTIFS : Invalid Data Type (Cross Sheet Referencing)
This assumes {OBH CM Referral Tracker Year} is formatted as text/number and {OBH CM Referral Tracker FF)} is formatted as date. Is this correct? =COUNTIFS({OBH CM Referral Tracker GG Prodigy Profile …1 · -
Re: One Conditional Formatting Rule Not Taking Priority
Is the cell color for the "children is 0" condition set to "no background" or "white"? I have found that using "no background" is sometimes (maybe all the time…2 · -
Re: How often can an IF function be boxed/nested?
I just did some testing (your question made me curious) and I cannot see there is a hard limit. The limit would appear to be as many as you can fit into the character limit of 4000. 253 nested IFs de…1 · -
Re: I can't delete cross sheet references
Deleting references has always been flaky for me. Sometimes "unused" references disappear without deleting them, while references I have attempted to delete do not go away immediately, or u…1 · -
Re: Adding a 3rd criteria -- help with Syntax
Awesome @TamieC, I'm glad it's working for you. Regarding SUMIF/SUMIFS, I use SUMIFS exclusively. Even though it's purpose is for comparing more than one condition, it works for only one condition as…1 ·
